[dbo].[CustomerExperienceStatusChange]

Property	Value
Created	10:31:19 AM Tuesday, March 02, 2010
Last Modified	1:20:14 PM Thursday, February 23, 2012

Name	Data Type	Max Length (Bytes)
CustomerExperienceStatusChangeKey	uniqueidentifier	16
CustomerExperienceKey	uniqueidentifier	16
StatusChangedUserKey	uniqueidentifier	16
CustomerExperienceStatusChangeNote	nvarchar(250)	500
StatusChangedOn	datetime	8
CustomerExperienceStatusCode	char(2)	2
UpdatedOn	datetime	8
UpdatedByUserKey	uniqueidentifier	16
CreatedOn	datetime	8
CreatedByUserKey	uniqueidentifier	16

	Name	Columns	Unique
	PK_CustomerExperienceStatusChange_CustomerExperienceStatusChangeKey	CustomerExperienceStatusChangeKey
	IX_CustomerExperienceStatusChange_CreatedByUserKey	CreatedByUserKey
	IX_CustomerExperienceStatusChange_CustomerExperienceKey	CustomerExperienceKey
	IX_CustomerExperienceStatusChange_CustomerExperienceStatusCode	CustomerExperienceStatusCode
	IX_CustomerExperienceStatusChange_StatusChangedUserKey	StatusChangedUserKey
	IX_CustomerExperienceStatusChange_UpdatedByUserKey	UpdatedByUserKey

Name	Columns
FK_CustomerExperienceStatusChange_CustomerExperience	CustomerExperienceKey->[dbo].[CustomerExperience].[CustomerExperienceKey]
FK_CustomerExperienceStatusChange_CustomerExperienceStatusRef	CustomerExperienceStatusCode->[dbo].[CustomerExperienceStatusRef].[CustomerExperienceStatusCode]
FK_CustomerExperienceStatusChange_UserMain_CreatedBy	CreatedByUserKey->[dbo].[UserMain].[UserKey]
FK_CustomerExperienceStatusChange_UserMain_StatusChanged	StatusChangedUserKey->[dbo].[UserMain].[UserKey]
FK_CustomerExperienceStatusChange_UserMain_UpdatedBy	UpdatedByUserKey->[dbo].[UserMain].[UserKey]

SQL Script

CREATE TABLE [dbo].[CustomerExperienceStatusChange]
(
[CustomerExperienceStatusChangeKey] [uniqueidentifier] NOT NULL,
[CustomerExperienceKey] [uniqueidentifier] NOT NULL,
[StatusChangedUserKey] [uniqueidentifier] NOT NULL,
[CustomerExperienceStatusChangeNote] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StatusChangedOn] [datetime] NULL,
[CustomerExperienceStatusCode] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatedOn] [datetime] NULL,
[UpdatedByUserKey] [uniqueidentifier] NULL,
[CreatedOn] [datetime] NULL,
[CreatedByUserKey] [uniqueidentifier] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[CustomerExperienceStatusChange] ADD CONSTRAINT [PK_CustomerExperienceStatusChange_CustomerExperienceStatusChangeKey] PRIMARY KEY CLUSTERED ([CustomerExperienceStatusChangeKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CustomerExperienceStatusChange_CreatedByUserKey] ON [dbo].[CustomerExperienceStatusChange] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CustomerExperienceStatusChange_CustomerExperienceKey] ON [dbo].[CustomerExperienceStatusChange] ([CustomerExperienceKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CustomerExperienceStatusChange_CustomerExperienceStatusCode] ON [dbo].[CustomerExperienceStatusChange] ([CustomerExperienceStatusCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CustomerExperienceStatusChange_StatusChangedUserKey] ON [dbo].[CustomerExperienceStatusChange] ([StatusChangedUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CustomerExperienceStatusChange_UpdatedByUserKey] ON [dbo].[CustomerExperienceStatusChange] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CustomerExperienceStatusChange] ADD CONSTRAINT [FK_CustomerExperienceStatusChange_CustomerExperience] FOREIGN KEY ([CustomerExperienceKey]) REFERENCES [dbo].[CustomerExperience] ([CustomerExperienceKey])
GO
ALTER TABLE [dbo].[CustomerExperienceStatusChange] ADD CONSTRAINT [FK_CustomerExperienceStatusChange_CustomerExperienceStatusRef] FOREIGN KEY ([CustomerExperienceStatusCode]) REFERENCES [dbo].[CustomerExperienceStatusRef] ([CustomerExperienceStatusCode])
GO
ALTER TABLE [dbo].[CustomerExperienceStatusChange] ADD CONSTRAINT [FK_CustomerExperienceStatusChange_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[CustomerExperienceStatusChange] ADD CONSTRAINT [FK_CustomerExperienceStatusChange_UserMain_StatusChanged] FOREIGN KEY ([StatusChangedUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[CustomerExperienceStatusChange] ADD CONSTRAINT [FK_CustomerExperienceStatusChange_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO